package com.ysh.mapper;

import com.ysh.pojo.Crimes;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ysh.pojo.CrimesMapVo;
import com.ysh.pojo.CrimesVo;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.time.LocalDate;
import java.time.LocalDateTime;
import java.util.Date;
import java.util.List;
import java.util.Map;

/**
* @author 嚴嚴嚴
* @description 针对表【crimes】的数据库操作Mapper
* @createDate 2023-12-11 17:52:53
* @Entity com.ysh.pojo.Crimes
*/
@Mapper
public interface CrimesMapper extends BaseMapper<Crimes> {

//    Map<String, CrimesVo> risk();

    List<String> Yearlist();

    List<CrimesVo> selectTop3(String year);


    int add( Crimes crimes);

    Integer selectByoffenceCode(Integer offenceCode);

}




